package com.woniuxy.patrol.mapper;

import com.woniuxy.patrol.pojo.PatrolRoute;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 13162
* @description 针对表【wcm_patrol_route(巡更路线表)】的数据库操作Mapper
* @createDate 2025-07-14 19:22:37
* @Entity com.woniuxy.patrol.pojo.PatrolRoute
*/
public interface PatrolRouteMapper extends BaseMapper<PatrolRoute> {

    /**
     * 根据社区ID查询路线
     */
    List<PatrolRoute> selectByCommunityId(@Param("communityId") Long communityId);
    /**
     * 根据计划ID查询路线（通过中间表关联）
     */
    List<PatrolRoute> selectByPlanId(@Param("planId") Long planId);

}




